Change the number of decimal places

The number of characters displayed in numbers after the decimal point can be reduced or increased. By default, two characters are displayed after the decimal point.

To do this, follow these steps:

1.Select the cell or range of cells that contain the required numbers.

2.Configure the display in one of the following ways:

On the Home tab, in the Number format group, click editor_delete_zero_icon Decrease decimals or editor_add_zero_icon Increase decimals.

Open the number format settings window, select the Accounting format and specify the required Decimal places using the counter.

 

When the number of characters decreases, the last visible digit is automatically rounded depending on the character to be hidden. Rounding is performed according to standard rules.

 

© New Cloud Technologies Ltd., 2013—2025
MyOffice Spreadsheet 3.5E